
version 15
capture log close
set more off
clear
clear matrix
clear mata

if c(username)=="WB485280" {
		glo rootdir		"C:\Users\wb485280\OneDrive - WBG\radicalization"
		}
if c(username)=="WB382635" {
		glo rootdir		"C:\Users\wb382635\Dropbox\Unemp & daesh"
		}
if c(username)=="WB452275" {
		glo rootdir		"C:\Users\WB452275\Dropbox\Projects\Unemp & daesh"
		}
if c(username)=="sarurchaudhary" {
		glo rootdir		"/Users/sarurchaudhary/Dropbox/Unemp & daesh"
		}
if c(username)=="kartikabhatia" {
			glo rootdir		"/Users/kartikabhatia/Dropbox/Before2019/Unemp & daesh"
			}
			
		glo	datadir     "${rootdir}/Data/Raw data"
		glo outdir		"${rootdir}/Data/Working datasets"
		glo dodir		"${rootdir}/Dofiles"
        
		cd "${outdir}"
		
	    log using turkey_visa_prep, replace t

* ------------------------------------------------------------------------------
* Date : Nov 2020 [chkd oct 2021]


* Project : Daesh Paper revision for RES


* This do file prepares the visa rules database for merge

* Database used : turkey_visa


* Output : visa.dta

* ------------------------------------------------------------------------------

* Preparing the visa data for merge

import excel using "${datadir}/turkey_visa.xlsx", firstrow clear 
		 	  
sort countryname year	
	
label define visa 0 "no" 1 "yes"	
label values visa_free visa

save "/Users/kartikabhatia/Dropbox/Before2019/Unemp & daesh/Data/Working datasets/visa.dta" , replace

log close
